
if exists(select name from sysobjects where name = 'sp_YKienCreateTraLoi')
	drop proc sp_YKienCreateTraLoi
go
/*
	Created by: Phuoc NH
	Created on: 13/012/2013 (dd/mm/yyyy)
	Description: 
	--

	File:$sql-scripts/Proc.sp_YKienCreateTraLoi.sql
*/

create proc sp_YKienCreateTraLoi
	
	@NoiDung Nvarchar(max),
	@NguoiGui varchar(50),
	@YKienIdCha int
as
begin
	insert into YKien(NoiDung, NguoiGui, TrangTHai, NgayGui, YKienIdcha) values(@NoiDung, @NguoiGui, 1, GETDATE(), @YKienIdCha)
	
end


